This campaign is tailored to elevate your SQL skills by delving deeper into more sophisticated concepts. Building on the foundation laid in the SQL Fundamentals, we’ll introduce you to versatile and efficient features that simplify complex queries, enhance code readability, and unlock new possibilities in SQL data manipulation.
This campaign equips you with a comprehensive understanding of SQL functions, enabling you to tackle real-world data challenges with confidence. Whether you’re a seasoned database administrator, a data analyst, or a software developer, this campaign will empower you to retrieve, analyze, and organize data effectively and efficiently.
Here are some few things that will be covered.
Quest 1
Use advanced filtering functions.
Understand and use the CASE WHEN function.
Write subqueries.
Use and apply Common Table Expressions.
Quest 2
Partition data and perform analysis on them.
Fetch and rank data.
Perform aggregate functions on frames.
Understand LEAD/LAG clauses.
Describe bounded and unbounded statements.
Quest 3
Handle date and time data types. Perform arithmetic operations on date time data. Manipulate text data.
